﻿-- =============================================
-- Author:		Artem Likhenko	
-- Create date: 1/30/2016
-- Description:	Insert new category to database
-- =============================================
CREATE PROCEDURE usp_Category_Insert 
	@CategoryName varchar(50)
AS
BEGIN
	INSERT INTO Category(CategoryName) 
	VALUES (@CategoryName);

	SELECT SCOPE_IDENTITY();
END